import cufflinks as cf
import pandas as pd
import numpy as np
import plotly.offline as py
import plotly.graph_objs as go
from IPython.display import display, Markdown, Latex
py.init_notebook_mode(connected=True)
cf.set_config_file(offline=True)
dtype = {'County': np.str,
'Employee Name': np.str,
'Job Title': np.str,
'Year': np.int64,
'Notes': np.str,
'Agency': np.str,
'Status': np.str}
def to_float(x):
try:
return float(x)
except Exception as e:
return None
converters = {'Base Pay': to_float,
'Overtime Pay': to_float,
'Other Pay': to_float,
'Benefits': to_float,
'Total Pay': to_float,
'Total Pay & Benefits': to_float}
df = pd.read_csv("data.csv.gz", compression='gzip', dtype=dtype, converters=converters)
ENTITIES_MAPPING = {
'Teachers': 'teacher',
'Managers': 'principal|director|chief|intendent'
}
ENTITIES = ['Teachers', 'Managers']
YEARS = [2016, 2015, 2014, 2013, 2012]
COUNTIES = ['San Mateo County']
def get_df(county, entity, year):
return df[(df['County'] == county) &
(df['Job Title'].str.contains("(?i){entity}".format(entity=ENTITIES_MAPPING[entity]))) &
(df['Year'] == year)]
def display_mean_salary_by_year(county, entity, year):
ga = get_df(county, entity, year).groupby(['Agency'])['Total Pay & Benefits']
ga_mean = ga.mean()
ga_mean = ga_mean.to_frame().reset_index().sort_values(by='Total Pay & Benefits', ascending=False)
bar = go.Bar(x=ga_mean['Agency'],
y=ga_mean['Total Pay & Benefits'],
marker=dict(color=np.where(ga_mean['Agency'] == 'San Mateo-Foster City', 'rgba(222,45,38,0.8)', 'rgba(204,204,204,1)').tolist()))
layout = go.Layout(
margin=go.Margin(
l=60,
r=50,
b=150,
t=100,
pad=2
),
title='{county}, {entity}, Mean Salary - {year}'.format(county=county,
entity=entity,
year=year),
xaxis=dict(
title='Agency',
tickfont=dict(
size=14,
color='rgb(107, 107, 107)'
)
),
yaxis=dict(
title='Mean Salary (USD)',
titlefont=dict(
size=16,
color='rgb(107, 107, 107)'
),
tickfont=dict(
size=14,
color='rgb(107, 107, 107)'
)
)
)
fig = go.Figure(data=[bar], layout=layout)
py.offline.iplot(fig, filename='basic-bar')
"""
ga_mean.iplot(title='{county}, {entity}, Mean Salary - {year}'.format(county=county,
entity=entity,
year=year),
x='Agency', kind='bar', filename='cufflinks/grouped-bar-chart',
xTitle='Agencies', yTitle='Mean Salary', colors={'Agency': 'red', 'Total Pay & Benefits': 'black'})
"""
# print table under graph
display(ga.describe().sort_values(by='mean', ascending=False))
for county in COUNTIES:
for k in ENTITIES:
display(Markdown('# {county}, {entity}, Mean Salary in {year_from} - {year_to}'.format(county=county,
entity=k,
year_from=min(YEARS),
year_to=max(YEARS))))
for year in YEARS:
display_mean_salary_by_year(county, k, year)
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| Portola Valley Elementary | 51.0 | 114308.219020 | 35249.918013 | 24441.29 | 103155.8500 | 121072.10 | 141348.2650 | 155939.98 |
| Las Lomitas Elementary | 86.0 | 112186.286860 | 34589.274925 | 17674.21 | 101644.4400 | 124789.11 | 135003.1050 | 162679.42 |
| Menlo Park City Elementary | 197.0 | 109100.831675 | 31872.646527 | 4772.96 | 93540.9600 | 120378.59 | 132307.0000 | 149728.85 |
| San Mateo Union High | 516.0 | 89637.898624 | 55348.637580 | 0.00 | 43487.9725 | 110342.98 | 136326.1075 | 177103.02 |
| Redwood City Elementary | 414.0 | 84091.860145 | 30399.758222 | 3467.76 | 66821.5800 | 90014.50 | 108050.1200 | 130262.17 |
| San Mateo County Office of Education | 98.0 | 81386.744898 | 51924.932731 | 161.00 | 34584.7500 | 87253.00 | 130387.5000 | 162407.00 |
| San Mateo-Foster City | 671.0 | 80915.340134 | 34628.192956 | 0.00 | 56369.8450 | 88089.60 | 109455.3500 | 130813.29 |
| San Carlos Elementary | 179.0 | 80820.370000 | 30054.581153 | 10515.54 | 62665.3750 | 93103.93 | 101742.9000 | 118654.71 |
| Belmont-Redwood Shores Elementary | 212.0 | 80434.726415 | 30277.630425 | 1.00 | 63843.0000 | 84095.00 | 104613.7500 | 141135.00 |
| Pacifica School District | 166.0 | 78638.991265 | 31585.521205 | 0.00 | 56373.2525 | 88943.20 | 105053.9350 | 126200.80 |
| South San Francisco Unified | 361.0 | 76595.146814 | 26264.206634 | 0.00 | 65551.0000 | 79782.00 | 96918.0000 | 127910.00 |
| Burlingame Elementary | 184.0 | 74049.296196 | 27328.244889 | 4156.15 | 54526.6300 | 77799.64 | 96986.4500 | 116783.89 |
| Bayshore Elementary | 23.0 | 71390.652174 | 24179.923018 | 23153.00 | 64017.0000 | 76141.00 | 85656.5000 | 102482.00 |
| La Honda-Pescadero Unified | 38.0 | 66914.996579 | 30181.638608 | 24.70 | 47218.5150 | 72050.93 | 87400.4625 | 124795.88 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| San Mateo Union High | 388.0 | 117053.419407 | 38169.116191 | 1199.06 | 97240.6825 | 129096.210 | 146170.9600 | 195573.51 |
| Menlo Park City Elementary | 210.0 | 106634.159810 | 38686.061510 | 1314.29 | 85142.0375 | 121874.850 | 136013.6300 | 152600.47 |
| Woodside Elementary | 39.0 | 105741.350000 | 32786.614038 | 35032.81 | 85672.0350 | 115348.250 | 127850.4250 | 165303.09 |
| Hillsborough City Elementary | 135.0 | 105162.210370 | 36274.898210 | 14200.68 | 82639.9600 | 117400.880 | 132841.8800 | 156858.61 |
| San Carlos Elementary | 180.0 | 83407.442056 | 27958.945131 | 466.41 | 71778.0475 | 93333.765 | 103788.5975 | 120869.68 |
| San Mateo-Foster City | 629.0 | 83212.395008 | 29649.920508 | 0.00 | 66751.6200 | 90426.970 | 106376.2700 | 130413.40 |
| Cabrillo Unified | 184.0 | 81777.165978 | 34833.832782 | 881.28 | 62324.3800 | 85248.490 | 110965.5075 | 151335.71 |
| South San Francisco Unified | 462.0 | 79156.752078 | 26248.529575 | 7958.79 | 66955.5950 | 84441.055 | 100269.8175 | 134160.62 |
| Jefferson Elementary | 352.0 | 78553.438267 | 29733.544352 | 1159.30 | 62450.7850 | 85683.545 | 101899.6775 | 130453.74 |
| Las Lomitas Elementary | 147.0 | 76413.640408 | 60059.383481 | 0.00 | 5274.0450 | 96178.840 | 131790.1800 | 164809.81 |
| Pacifica School District | 167.0 | 74941.960838 | 32807.893235 | 279.69 | 44251.4650 | 84648.410 | 102492.5250 | 124831.43 |
| Millbrae Elementary | 145.0 | 72698.632207 | 31377.970924 | 1219.43 | 42626.0000 | 78673.190 | 100827.2700 | 122979.02 |
| La Honda-Pescadero Unified | 37.0 | 72450.631351 | 33348.148371 | 66.35 | 60311.7900 | 80146.950 | 92991.6200 | 129516.80 |
| Belmont-Redwood Shores Elementary | 293.0 | 62663.578669 | 44117.376622 | 75.50 | 17713.8200 | 70308.950 | 101781.4100 | 138947.88 |
| Redwood City Elementary | 683.0 | 58250.725256 | 40445.781841 | 0.00 | 18701.5100 | 59961.680 | 97720.3450 | 127244.90 |
| Bayshore Elementary | 26.0 | 57759.400769 | 28857.414005 | 3612.80 | 34075.6750 | 65248.930 | 75227.9475 | 103615.24 |
| Burlingame Elementary | 289.0 | 52548.259758 | 39689.071425 | 0.00 | 10129.9100 | 52903.210 | 91831.6400 | 115200.73 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| Portola Valley Elementary | 52.0 | 105835.640962 | 37843.494669 | 19043.07 | 84528.1450 | 118646.980 | 136825.6275 | 150799.05 |
| San Mateo Union High | 416.0 | 103967.956082 | 39288.931495 | 0.00 | 79755.1200 | 116578.340 | 134148.1225 | 174815.47 |
| Menlo Park City Elementary | 186.0 | 100413.679355 | 29965.087940 | 11063.51 | 84839.6175 | 111633.745 | 122127.9225 | 155511.51 |
| Hillsborough City Elementary | 121.0 | 100334.018099 | 32384.399559 | 2340.89 | 84872.4300 | 112626.720 | 124116.3900 | 143246.43 |
| San Mateo County Office of Education | 103.0 | 87739.738835 | 39363.815048 | 395.31 | 66196.7950 | 107152.760 | 119103.0500 | 136965.99 |
| Jefferson Elementary | 332.0 | 76217.283343 | 25110.283448 | 3763.12 | 63432.5300 | 82794.685 | 95520.4375 | 119883.27 |
| Belmont-Redwood Shores Elementary | 217.0 | 74392.099355 | 30452.177747 | 3774.79 | 49936.4900 | 80745.930 | 100871.8900 | 126241.04 |
| Redwood City Elementary | 495.0 | 74273.028343 | 30093.956590 | 351.67 | 48675.1450 | 77395.720 | 99867.0950 | 121788.88 |
| Brisbane Elementary | 37.0 | 73454.801081 | 28064.801734 | 11053.65 | 50678.8100 | 85438.750 | 94788.6700 | 118708.63 |
| Pacifica School District | 165.0 | 73329.545758 | 31912.636493 | 678.11 | 44900.9200 | 83471.820 | 100356.1400 | 121840.67 |
| Ravenswood City Elementary | 197.0 | 71128.684619 | 25138.881238 | 0.00 | 56524.6700 | 73807.540 | 88427.7300 | 115228.80 |
| Millbrae Elementary | 139.0 | 71015.978201 | 30785.372272 | 17.22 | 46388.6500 | 78047.890 | 96976.9750 | 119780.36 |
| Las Lomitas Elementary | 148.0 | 69855.697703 | 53580.997176 | 160.59 | 7628.1150 | 78512.025 | 120401.0125 | 150214.89 |
| San Carlos Elementary | 166.0 | 67331.713735 | 20636.466296 | 7099.70 | 56748.8775 | 72876.010 | 81953.3250 | 92283.37 |
| Jefferson Union High | 307.0 | 67162.868013 | 36646.405483 | 787.85 | 36045.0050 | 73695.530 | 96644.9100 | 139596.81 |
| San Bruno Park Elementary | 127.0 | 67075.628976 | 22418.212869 | 10196.68 | 54798.2050 | 72355.320 | 83035.3600 | 102585.78 |
| San Mateo-Foster City | 689.0 | 66616.075849 | 39514.742097 | 0.00 | 29700.6700 | 74407.940 | 98813.2800 | 146467.25 |
| La Honda-Pescadero Unified | 39.0 | 65014.450000 | 30052.891996 | 12498.98 | 37932.8850 | 63799.980 | 91097.8600 | 111784.48 |
| Burlingame Elementary | 300.0 | 47605.959067 | 39188.397976 | 66.00 | 3930.7500 | 47564.800 | 84949.2275 | 109924.81 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| San Mateo Union High | 438.0 | 106746.377466 | 32364.589033 | 6441.78 | 91408.7975 | 118055.935 | 130396.8425 | 168120.68 |
| Menlo Park City Elementary | 185.0 | 105104.414703 | 30059.186691 | 24090.59 | 94554.8200 | 115788.830 | 126987.8800 | 153199.80 |
| Portola Valley Elementary | 51.0 | 100642.726078 | 32682.519865 | 27403.30 | 83698.2400 | 111475.080 | 127329.1850 | 142243.51 |
| Woodside Elementary | 42.0 | 91489.523333 | 35015.897871 | 27239.60 | 61736.5725 | 105456.310 | 119330.6000 | 153219.27 |
| Sequoia Union High | 561.0 | 90095.171961 | 42362.880521 | 137.12 | 53709.9600 | 103786.260 | 125135.6000 | 156745.76 |
| San Mateo County Office of Education | 107.0 | 86761.852991 | 43038.564355 | 172.39 | 46162.7700 | 108267.940 | 119327.4400 | 136325.97 |
| Brisbane Elementary | 31.0 | 77818.666774 | 18070.359894 | 18839.57 | 71261.1650 | 81433.830 | 87380.9600 | 105451.17 |
| San Carlos Elementary | 161.0 | 76820.162298 | 25046.030843 | 10598.42 | 63564.8700 | 82375.410 | 97196.7100 | 112622.01 |
| Redwood City Elementary | 449.0 | 75288.017951 | 25819.079886 | 1834.92 | 60152.6300 | 81916.510 | 96344.2400 | 116783.84 |
| Cabrillo Unified | 183.0 | 75205.049508 | 36026.067850 | 110.00 | 49244.5700 | 87243.610 | 104155.5400 | 142403.74 |
| Belmont-Redwood Shores Elementary | 205.0 | 73109.070537 | 30021.014470 | 2665.76 | 59466.5200 | 80115.690 | 97904.8800 | 123762.26 |
| Jefferson Elementary | 305.0 | 71644.482197 | 21574.008981 | 4925.83 | 58902.8600 | 77942.150 | 88039.2900 | 109289.78 |
| San Mateo-Foster City | 602.0 | 71214.452957 | 26121.344440 | 583.81 | 57438.8500 | 77823.610 | 91047.5850 | 112736.83 |
| Las Lomitas Elementary | 143.0 | 70782.838811 | 54023.507918 | 95.44 | 7836.5850 | 81882.300 | 122727.0400 | 152121.77 |
| South San Francisco Unified | 468.0 | 70256.048098 | 24695.864975 | 958.73 | 60398.0325 | 75477.730 | 89180.5775 | 122537.33 |
| Pacifica School District | 161.0 | 70103.760311 | 28779.303537 | 4844.49 | 53541.3900 | 78631.270 | 93947.8200 | 114053.43 |
| Millbrae Elementary | 126.0 | 69823.920714 | 27954.430841 | 5995.26 | 52522.7425 | 79981.635 | 94162.4125 | 112745.96 |
| Burlingame Elementary | 174.0 | 68961.492241 | 26729.159614 | 16394.88 | 46036.7975 | 74302.805 | 91756.5450 | 112808.86 |
| Ravenswood City Elementary | 213.0 | 65991.920563 | 26802.787115 | 2211.88 | 41526.0000 | 71886.560 | 85880.9700 | 111852.33 |
| Hillsborough City Elementary | 200.0 | 57354.300750 | 48936.884226 | 67.50 | 2530.3700 | 55736.105 | 108284.9700 | 140377.22 |
| Jefferson Union High | 320.0 | 55105.377406 | 37056.504768 | 3.64 | 16885.6475 | 64265.885 | 86367.0700 | 125814.87 |
| La Honda-Pescadero Unified | 42.0 | 51679.879524 | 30051.522997 | 1745.12 | 26156.1975 | 53969.835 | 74093.1175 | 108244.30 |
| Bayshore Elementary | 33.0 | 39379.459394 | 31633.674839 | 135.31 | 5022.8000 | 33913.540 | 63776.9000 | 97785.69 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| Redwood City Elementary | 1.0 | 106291.190000 | NaN | 106291.19 | 106291.1900 | 106291.190 | 106291.1900 | 106291.19 |
| Portola Valley Elementary | 51.0 | 103730.362745 | 36416.987905 | 12196.40 | 82261.1500 | 116476.300 | 131327.4600 | 147461.64 |
| San Mateo Union High | 448.0 | 102353.300915 | 32984.911957 | 219.40 | 85361.6225 | 114449.705 | 126636.8550 | 161873.28 |
| Menlo Park City Elementary | 175.0 | 98317.483029 | 27246.940768 | 16259.12 | 86321.9850 | 107683.840 | 118193.4350 | 138092.83 |
| Sequoia Union High | 463.0 | 97190.923866 | 31663.120873 | 2369.70 | 76728.0050 | 106057.000 | 121067.1750 | 152706.34 |
| San Mateo County Office of Education | 107.0 | 82472.189626 | 39042.438816 | 1442.17 | 61257.5350 | 101141.140 | 112090.6600 | 125511.89 |
| Belmont-Redwood Shores Elementary | 192.0 | 75600.078854 | 29794.200287 | 389.37 | 61106.5650 | 82535.865 | 100154.5525 | 120567.44 |
| Millbrae Elementary | 118.0 | 73237.939492 | 25669.150838 | 1129.65 | 59877.6925 | 82400.920 | 93143.4775 | 110617.36 |
| South San Francisco Unified | 475.0 | 71240.390589 | 23378.121732 | 3571.38 | 61071.0700 | 75791.690 | 89006.5850 | 123700.60 |
| Jefferson Elementary | 294.0 | 70895.214456 | 20457.987967 | 8.75 | 59641.2225 | 76396.025 | 86299.9850 | 104356.13 |
| Pacifica School District | 1.0 | 68010.680000 | NaN | 68010.68 | 68010.6800 | 68010.680 | 68010.6800 | 68010.68 |
| Burlingame Elementary | 168.0 | 67966.885774 | 23658.297316 | 124.49 | 52334.5025 | 72235.185 | 88342.0475 | 105432.58 |
| Las Lomitas Elementary | 140.0 | 66225.797357 | 52224.619640 | 121.74 | 4074.0750 | 76045.210 | 117819.3975 | 143552.72 |
| San Mateo-Foster City | 582.0 | 65746.562835 | 24875.457653 | 5265.89 | 47096.5850 | 72331.055 | 86252.9600 | 104866.65 |
| Jefferson Union High | 254.0 | 64031.084449 | 23561.854697 | 22.25 | 50859.1050 | 67971.275 | 81681.2000 | 121476.34 |
| Ravenswood City Elementary | 212.0 | 58770.823774 | 25177.607995 | 154.22 | 36492.7050 | 65393.615 | 77108.3975 | 100902.64 |
| Hillsborough City Elementary | 197.0 | 57593.772893 | 48096.593626 | 60.00 | 2617.6000 | 65825.390 | 106352.1000 | 136499.81 |
| Woodside Elementary | 69.0 | 56385.008116 | 49752.682222 | 159.06 | 2505.8000 | 57991.670 | 104225.3000 | 145463.08 |
| San Carlos Elementary | 229.0 | 56255.927991 | 39349.962461 | 43.71 | 9461.0900 | 68216.610 | 91471.2100 | 114395.08 |
| La Honda-Pescadero Unified | 37.0 | 53344.679459 | 27025.285021 | 2578.48 | 31291.4900 | 61565.280 | 70151.4500 | 97885.36 |
| Bayshore Elementary | 30.0 | 39795.116667 | 31961.471661 | 125.00 | 2765.6250 | 49401.620 | 65832.0200 | 95778.24 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| San Mateo Union High | 31.0 | 188238.368065 | 57809.139589 | 71660.30 | 171328.4550 | 187869.990 | 214945.4950 | 348435.74 |
| Portola Valley Elementary | 7.0 | 180136.747143 | 65742.967750 | 42479.98 | 182593.2400 | 187974.570 | 209274.5200 | 246767.16 |
| Menlo Park City Elementary | 16.0 | 179321.708750 | 34523.250819 | 140584.95 | 148191.7525 | 178038.995 | 198997.2975 | 274717.64 |
| San Mateo-Foster City | 41.0 | 166990.780976 | 46817.764106 | 43060.05 | 160921.6300 | 185196.750 | 192755.1100 | 270074.32 |
| Burlingame Elementary | 16.0 | 162261.766875 | 40885.781441 | 111612.22 | 141249.7425 | 153092.375 | 175045.0625 | 293857.48 |
| San Mateo County Office of Education | 19.0 | 156921.000000 | 69794.492170 | 307.00 | 137576.5000 | 167977.000 | 194805.5000 | 272407.00 |
| Las Lomitas Elementary | 12.0 | 151795.771667 | 51351.003733 | 64856.23 | 120715.8400 | 162376.710 | 178368.5250 | 248142.92 |
| Belmont-Redwood Shores Elementary | 16.0 | 147806.937500 | 38699.798546 | 78340.00 | 123041.0000 | 149778.500 | 167874.0000 | 234988.00 |
| Pacifica School District | 17.0 | 146165.937647 | 53597.249382 | 14546.44 | 131817.6500 | 150180.960 | 162938.2900 | 248636.70 |
| Redwood City Elementary | 42.0 | 145462.825000 | 41731.426639 | 64276.06 | 131574.0425 | 151397.195 | 168140.6250 | 268113.54 |
| San Carlos Elementary | 18.0 | 138092.575000 | 48904.466735 | 11095.54 | 127227.7100 | 138932.845 | 156218.1600 | 238839.36 |
| South San Francisco Unified | 30.0 | 129668.000000 | 46964.351686 | 0.00 | 103666.2500 | 142952.000 | 158681.0000 | 225309.00 |
| Bayshore Elementary | 4.0 | 108459.750000 | 63718.933190 | 54525.00 | 56265.7500 | 97654.000 | 149848.0000 | 184006.00 |
| La Honda-Pescadero Unified | 6.0 | 106035.880000 | 31954.599811 | 50338.65 | 94916.7175 | 117095.025 | 123246.0425 | 138866.25 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| Hillsborough City Elementary | 9.0 | 180800.321111 | 48691.111731 | 89546.44 | 178676.1300 | 188815.960 | 201455.0000 | 253150.62 |
| San Mateo Union High | 35.0 | 179364.508857 | 51950.716830 | 83158.91 | 157897.6050 | 184304.040 | 212086.1450 | 330816.69 |
| Las Lomitas Elementary | 12.0 | 164175.263333 | 52042.128677 | 64807.13 | 138380.9825 | 179541.060 | 195614.1725 | 235632.38 |
| San Mateo-Foster City | 39.0 | 163547.648462 | 40346.017049 | 55680.49 | 151279.9800 | 182760.170 | 188471.5800 | 209969.37 |
| Burlingame Elementary | 15.0 | 163290.935333 | 55282.291789 | 60098.64 | 153580.7350 | 163974.680 | 183922.6650 | 300712.30 |
| Woodside Elementary | 8.0 | 152223.303750 | 62430.850119 | 96975.96 | 102800.2800 | 148727.360 | 165407.8750 | 287480.51 |
| San Carlos Elementary | 16.0 | 151139.110625 | 40843.867221 | 65947.53 | 135040.6975 | 150910.715 | 163008.6725 | 246861.84 |
| Menlo Park City Elementary | 20.0 | 146769.108500 | 72683.671468 | 1320.89 | 84959.9125 | 166267.175 | 200791.6950 | 269385.57 |
| Pacifica School District | 16.0 | 143586.615000 | 51778.175134 | 49589.52 | 117958.8625 | 148467.150 | 170896.6250 | 237194.10 |
| Redwood City Elementary | 39.0 | 140820.036923 | 44175.732482 | 14975.72 | 131887.5450 | 152557.360 | 164632.1350 | 223152.08 |
| Belmont-Redwood Shores Elementary | 17.0 | 140485.691176 | 61757.174462 | 1480.75 | 138942.9800 | 164994.560 | 173561.0400 | 233844.88 |
| South San Francisco Unified | 32.0 | 132642.315625 | 37510.743848 | 37939.40 | 124617.1875 | 143527.350 | 151413.0875 | 205408.48 |
| Jefferson Elementary | 32.0 | 132317.989687 | 47399.814655 | 11055.74 | 110352.5350 | 150614.295 | 156865.3800 | 244588.82 |
| La Honda-Pescadero Unified | 5.0 | 130490.516000 | 10691.324150 | 118325.88 | 122842.1300 | 129516.800 | 136776.0200 | 144991.75 |
| Cabrillo Unified | 20.0 | 126984.943000 | 37431.220189 | 57603.29 | 96715.6525 | 134913.920 | 147660.6125 | 200071.38 |
| Millbrae Elementary | 14.0 | 114471.565000 | 51463.792234 | 48777.38 | 61762.2275 | 123167.405 | 152566.8975 | 185831.11 |
| Bayshore Elementary | 4.0 | 85788.060000 | 34855.370881 | 56680.98 | 61627.8075 | 76491.225 | 100651.4775 | 133488.81 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| Hillsborough City Elementary | 9.0 | 181169.812222 | 31783.703017 | 111214.08 | 177599.6500 | 179517.220 | 192084.6100 | 230110.31 |
| San Mateo Union High | 34.0 | 179583.057353 | 63800.059716 | 67855.19 | 146944.3225 | 193358.545 | 214268.9650 | 349292.66 |
| San Mateo County Office of Education | 15.0 | 171824.753333 | 42039.612935 | 112399.23 | 154657.7250 | 160899.900 | 192750.1500 | 269154.10 |
| Las Lomitas Elementary | 11.0 | 169416.515455 | 36724.891355 | 87928.76 | 157297.4750 | 180683.390 | 184717.9050 | 222583.06 |
| Portola Valley Elementary | 6.0 | 154655.211667 | 68101.011995 | 43745.94 | 119738.8350 | 181106.540 | 197847.6250 | 219261.33 |
| Burlingame Elementary | 14.0 | 147353.475714 | 46239.626580 | 85085.58 | 128919.5100 | 150926.520 | 160606.8800 | 269387.20 |
| Menlo Park City Elementary | 17.0 | 144489.420588 | 53016.319870 | 21375.38 | 127400.9000 | 156662.770 | 175083.7300 | 237957.52 |
| San Mateo-Foster City | 44.0 | 142133.094545 | 51832.366683 | 3285.24 | 138346.9900 | 159025.190 | 164019.5050 | 295265.20 |
| Pacifica School District | 15.0 | 142035.239333 | 48802.133605 | 54837.09 | 123938.6050 | 152575.980 | 162585.1250 | 229580.87 |
| Belmont-Redwood Shores Elementary | 14.0 | 135555.767143 | 43988.694104 | 62544.65 | 117238.4250 | 143240.910 | 152731.1800 | 230557.28 |
| Redwood City Elementary | 43.0 | 129560.791860 | 48787.557498 | 863.21 | 120327.9500 | 144624.910 | 157269.1350 | 229521.57 |
| Ravenswood City Elementary | 22.0 | 124625.576364 | 35159.635501 | 64941.02 | 115191.4250 | 133356.900 | 139483.5275 | 219733.88 |
| Jefferson Elementary | 32.0 | 118060.531875 | 48631.019374 | 10085.22 | 76929.2675 | 138715.010 | 143836.4400 | 225706.35 |
| San Carlos Elementary | 15.0 | 116900.909333 | 22790.031382 | 72134.56 | 108930.3300 | 117762.960 | 124632.1100 | 171667.00 |
| Jefferson Union High | 30.0 | 114744.606000 | 53042.964687 | 489.14 | 73619.1825 | 131492.345 | 149925.6300 | 225689.78 |
| La Honda-Pescadero Unified | 5.0 | 109192.750000 | 8997.909133 | 100878.14 | 101856.1700 | 105995.600 | 116063.5300 | 121170.31 |
| San Bruno Park Elementary | 12.0 | 97827.477500 | 27878.938228 | 30670.58 | 86900.5400 | 103920.205 | 106481.0400 | 147856.33 |
| Millbrae Elementary | 15.0 | 96670.515333 | 62496.138707 | 328.69 | 49454.3200 | 94317.800 | 142291.3000 | 209097.50 |
| Brisbane Elementary | 6.0 | 86987.401667 | 66854.664255 | 2191.88 | 50682.9275 | 79517.390 | 112352.6450 | 196328.58 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| San Mateo Union High | 29.0 | 174610.090345 | 37343.996983 | 65133.59 | 163524.1000 | 178442.240 | 187430.0400 | 258306.10 |
| Menlo Park City Elementary | 13.0 | 152274.036154 | 55485.917033 | 18852.54 | 143425.0600 | 150900.460 | 185098.2100 | 245983.71 |
| Las Lomitas Elementary | 10.0 | 151517.413000 | 51373.593400 | 23094.62 | 151314.2200 | 166578.730 | 175308.2250 | 213357.76 |
| Hillsborough City Elementary | 11.0 | 149780.548182 | 45589.322120 | 82671.33 | 117504.3050 | 164223.510 | 175083.0150 | 228250.83 |
| Sequoia Union High | 21.0 | 149521.128095 | 59225.921590 | 5816.90 | 142494.6200 | 166466.970 | 183608.1100 | 253867.20 |
| San Mateo County Office of Education | 16.0 | 147809.639375 | 56417.206718 | 29261.07 | 107509.1250 | 151154.515 | 185551.1375 | 240595.31 |
| San Mateo-Foster City | 36.0 | 145454.551111 | 36159.075157 | 58301.25 | 138502.5100 | 150877.105 | 155011.2175 | 282214.43 |
| Woodside Elementary | 6.0 | 138135.421667 | 67761.076844 | 41176.92 | 100659.1150 | 145226.730 | 168350.5550 | 235320.41 |
| Pacifica School District | 13.0 | 137986.120000 | 40797.000920 | 48149.41 | 124462.5800 | 136397.320 | 155031.4900 | 211025.07 |
| Burlingame Elementary | 12.0 | 130820.462500 | 57985.228145 | 52437.15 | 78320.5275 | 145302.760 | 151915.6550 | 250942.90 |
| South San Francisco Unified | 34.0 | 127547.124118 | 29951.534336 | 54590.37 | 117912.6800 | 125232.950 | 140487.0625 | 226915.94 |
| Jefferson Elementary | 27.0 | 124934.866296 | 27088.220443 | 50362.61 | 115391.3850 | 124849.650 | 135243.3550 | 202870.52 |
| Jefferson Union High | 24.0 | 119422.918333 | 32177.159461 | 34969.11 | 104889.8425 | 119926.770 | 134103.1350 | 202264.92 |
| San Carlos Elementary | 15.0 | 119201.788667 | 45586.651523 | 28793.78 | 95778.9050 | 132528.300 | 139505.6700 | 216285.71 |
| Ravenswood City Elementary | 24.0 | 118728.525417 | 35708.234624 | 43308.32 | 104135.2550 | 124797.545 | 141064.1900 | 177308.07 |
| Belmont-Redwood Shores Elementary | 19.0 | 118533.848947 | 38676.604849 | 66349.20 | 87152.7200 | 114703.600 | 144310.9300 | 219341.77 |
| Redwood City Elementary | 42.0 | 116009.933333 | 38733.863109 | 34401.89 | 84208.4700 | 124649.430 | 145017.4075 | 222483.60 |
| Bayshore Elementary | 2.0 | 114167.580000 | 1071.691038 | 113409.78 | 113788.6800 | 114167.580 | 114546.4800 | 114925.38 |
| Millbrae Elementary | 12.0 | 104993.597500 | 55724.134015 | 30219.41 | 49558.5625 | 125105.885 | 129884.4700 | 208543.22 |
| Brisbane Elementary | 4.0 | 104810.077500 | 74776.691374 | 19635.50 | 69039.4025 | 99802.460 | 135573.1350 | 199999.89 |
| Portola Valley Elementary | 5.0 | 97005.250000 | 56071.151727 | 32480.14 | 86928.9500 | 89070.580 | 89070.5800 | 187476.00 |
| Cabrillo Unified | 23.0 | 92846.356957 | 58925.935493 | 132.00 | 48843.6150 | 99992.670 | 139522.1700 | 212956.80 |
| La Honda-Pescadero Unified | 4.0 | 92784.332500 | 13539.533237 | 80864.83 | 86600.2900 | 89011.255 | 95195.2975 | 112249.99 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| Portola Valley Elementary | 3.0 | 196362.470000 | 18333.603175 | 182528.68 | 185965.1700 | 189401.660 | 203279.3650 | 217157.07 |
| Woodside Elementary | 3.0 | 175041.876667 | 45183.765210 | 138713.16 | 149744.4200 | 160775.680 | 193206.2350 | 225636.79 |
| San Mateo Union High | 30.0 | 173871.018667 | 39811.625978 | 42959.22 | 159690.7925 | 178330.425 | 187605.5600 | 256250.04 |
| Sequoia Union High | 13.0 | 166950.480769 | 36371.650572 | 89080.97 | 146889.6300 | 173254.390 | 182101.4500 | 247151.76 |
| San Mateo County Office of Education | 13.0 | 155722.933077 | 37554.853919 | 80678.60 | 140504.7900 | 160898.330 | 175217.8700 | 225169.08 |
| Menlo Park City Elementary | 12.0 | 153029.810000 | 44490.769543 | 77499.89 | 128323.1050 | 160746.950 | 179149.7675 | 239775.73 |
| Burlingame Elementary | 11.0 | 137997.866364 | 49220.679172 | 53570.02 | 138168.4200 | 139949.190 | 152714.2400 | 235077.69 |
| Hillsborough City Elementary | 12.0 | 134573.834167 | 47211.217664 | 60812.68 | 92941.5950 | 151601.880 | 161392.7175 | 221387.78 |
| Millbrae Elementary | 9.0 | 133744.924444 | 38292.601909 | 57249.90 | 125513.5500 | 132357.430 | 148152.9000 | 200738.98 |
| Belmont-Redwood Shores Elementary | 16.0 | 131621.450625 | 42031.476511 | 57996.80 | 102749.7650 | 143481.645 | 158409.8775 | 204954.78 |
| Jefferson Elementary | 23.0 | 120422.289130 | 27386.568416 | 37805.39 | 111583.6000 | 119928.130 | 128084.1850 | 193615.91 |
| Ravenswood City Elementary | 20.0 | 113298.292500 | 33958.727390 | 23336.36 | 101309.1850 | 117317.070 | 124494.3450 | 195853.86 |
| South San Francisco Unified | 35.0 | 112020.050286 | 34741.471399 | 44560.16 | 98284.9750 | 117120.980 | 130195.5500 | 208827.57 |
| Las Lomitas Elementary | 13.0 | 110235.785385 | 48377.669536 | 16877.43 | 78674.1800 | 106692.600 | 156093.4000 | 171198.28 |
| San Mateo-Foster City | 36.0 | 110072.339722 | 35378.775796 | 34513.53 | 105150.9425 | 119372.875 | 122299.4775 | 234083.11 |
| San Carlos Elementary | 15.0 | 109776.440000 | 52289.832169 | 3403.92 | 102270.4950 | 121359.870 | 133254.8500 | 213404.86 |
| Bayshore Elementary | 2.0 | 108843.265000 | 1063.594665 | 108091.19 | 108467.2275 | 108843.265 | 109219.3025 | 109595.34 |
| Jefferson Union High | 31.0 | 90777.020968 | 37540.635744 | 11790.66 | 58088.4100 | 94270.920 | 116867.3550 | 188310.28 |
| La Honda-Pescadero Unified | 7.0 | 77049.857143 | 33199.203870 | 11674.89 | 69059.8250 | 85020.750 | 98251.7650 | 108030.18 |
All stats are based on: https://transparentcalifornia.com/agencies/salaries/school-districts/